Oracle Database 19c: New Features for Administrators

Beschreibung

The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability.

• Topics of the database overall module cover new features such as DBCA, OUI, and Data Pump enhancements.
• Topics of the security module cover enhancements such as key management of encrypted Oracle-managed tablespaces in TDE, and Database Vault operations control.
• Topics of the availability module cover enhancements in RMAN such as recovery catalog connection when the user is connected to the target database as PDB.
• Topics of the performance module cover enhancements such as PDB-level ADDM analysis, Memoptimized Rowstore - Fast Ingest deferred writes and enabling SQL developers to use Real-Time SQL Monitor.
• Topics of the data warehousing module cover enhancements such as hybrid partitioned tables and automated indexing.
• Topics of the diagnosability module cover new features such as an end-to-end automated service for fault prediction, detection, and fixation to avoid or minimize the human intervention, and new service request data collections determining the data to collect for crucial errors.
• Topics of the sharding module cover enhancements such as the support for multiple PDB-shards in the same CDB and of multiple table family for system-managed sharding.

Benefits to You

The Multitenant architecture lesson covers CDB fleet, PDB snapshots carousel, dynamic container map, lockdown profile inheritance, static & dynamic lockdown profiles, refreshable copy PDB switchover, parallel statement queuing at PDB level and PDB cloning with DBCA.

The Security lesson covers schema only accounts, PDB keystore in isolated mode versus united mode, user-defined TDE master key, export and import database links, encryption of sensitive data in Database Replay files, Database Replay capture and replay with Database Vault,and direct Active Directory Services integration.

The RMAN lesson covers reuse of preplugin backups before and after a non-CDB conversion as a PDB or of a PDB migration to another CDB, clone of active PDBs into another CDB using DUPLICATE command, duplication of on-premises CDBs to Cloud as encrypted.

The General Database lesson covers private temporary tables, Data Pump import with a new option of the DATA_OPTIONS parameter, online modification of partitioning and subpartitioning strategy, online merging partitions and subpartitions, batched DDL generation by using DBMS_METADATA_DIFF package, and benefit from Unicode 9.0 Support.

The Performance lesson covers configuration and usage of Automatic In-Memory, IMEs window capture, memoptimized rowstore feature and use of In-Memory Hash Index structures, description of the new SQL Tuning Set package, the concurrency of SQL execution of SQL Performance Analyzer tasks, the SQL Performance Analyzer Result Set Validation, SQL Exadata-aware profile.

The Data Warehousing lesson covers query inlined external tables, in-memory external tables, analytic view new query capabilities, polymorphic table functions and the new functions for approximate Top-N queries.

The Sharding lesson covers the user-defined sharding method, support for PDBs as shards, Oracle GoldenGate enhancements for Oracle Sharding support, query system objects across shards, how to set multi-shard query data consistency level, sharding support for JSON, LOBs, and spatial objects, improved multi-shard query enhancements, and where to find Oracle Sharding documentation in Oracle Database 18c.

Hands-on Practices and Demonstrations

Hands-on practices and available demonstrations help you learn how to use these new or enhanced features of Oracle Database 19c.